﻿CREATE TABLE [dbo].[Usuarios] (
    [UsuarioGuid]      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [TenenciaGuid]     UNIQUEIDENTIFIER NULL,
    [TenenciaId]       INT              NOT NULL,
    [RiegoSistemaGuid] UNIQUEIDENTIFIER NULL,
    [RiegoSistemaId]   INT              NOT NULL,
    [EstadoGuid]       UNIQUEIDENTIFIER NULL,
    [EstadoId]         INT              NOT NULL,
    [DistritoGuid]     UNIQUEIDENTIFIER NULL,
    [DistritoId]       INT              NULL,
    [MunicipioGuid]    UNIQUEIDENTIFIER NULL,
    [MunicipioId]      INT              NULL,
    [EjidoGuid]        UNIQUEIDENTIFIER NULL,
    [EjidoId]          INT              NULL,
    [ModuloGuid]       UNIQUEIDENTIFIER NULL,
    [ModuloId]         INT              NULL,
    [SeccionGuid]      UNIQUEIDENTIFIER NULL,
    [SeccionId]        INT              NULL,
    [JuntaGuid]        UNIQUEIDENTIFIER NULL,
    [JuntaId]          INT              NULL,
    [Nombre]           NVARCHAR (250)   NOT NULL,
    [Superficie]       DECIMAL (18, 4)  NOT NULL,
    [Padron]           NVARCHAR (50)    NULL,
    [SubPadron]        NVARCHAR (50)    NULL,
    [Control]          NVARCHAR (50)    NULL,
    [Predio]           NTEXT            NULL,
    [PozoNumero]       NVARCHAR (50)    NULL,
    [PozoConcesion]    NVARCHAR (50)    NULL,
    [Oficio]           NVARCHAR (50)    NULL,
    [OficioFecha]      DATETIME         NULL,
    [Status]           BIT              NOT NULL
);


GO
ALTER TABLE [dbo].[Usuarios] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF);

